package com.example.zjsr.domain;


import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.metadata.BaseRowModel;
import lombok.Data;

@Data
public class ExcelFruitInfo extends BaseRowModel {

    @ExcelIgnore
    private Integer infoId;//序号

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 0, value = "宝贝标题")
    private String title;//宝贝标题

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 1, value = "主图链接")
    private String pictureMap;//主图链接

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 2, value = "销售价最低")
    private double lowSales;//销售价最低

    @ExcelProperty(index = 3, value = "库存")
    private Integer inventory;//库存

    @ExcelProperty(index = 4, value = "邮费")
    private String postage;//邮费

    @ExcelProperty(index = 5, value = "总销量")
    private Integer totalSales;//总销量

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 6, value = "总销售额")
    private String grossSales;//总销售额

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 7, value = "30天销量")
    private String thirtyDaysSales;//30天销量

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 8, value = "销量占比")
    private String salesAccounted;//销量占比

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 9, value = "30天销售额")
    private String thirtyDaysSaleroom;//30天销售额

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 10, value = "销售额占比")
    private String saleroom;//销售额占比

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 11, value = "总收藏量")
    private String collection;//总收藏量

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 12, value = "总评价数量")
    private String evaluationSeveral;//总评价数量

    @ExcelProperty(index = 13, value = "发货地")
    private String placeDispatch;//发货地

    @ExcelProperty(index = 14, value = "好评率")
    private String favorableRate;//好评率

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 15, value = "热卖时间")
    private String sellingTime;//热卖时间

    @ExcelProperty(index = 16, value = "净含量")
    private String netContent;//净含量

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 17, value = "售卖方式")
    private String sellingWay;//售卖方式

    @ExcelProperty(index = 18, value = "城市")
    private String city;//城市

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 19, value = "包装方式")
    private String mannerPacking;//包装方式

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 20, value = "配送频次")
    private String distFre;//配送频次

    @ExcelProperty(index = 21, value = "省份")
    private String province;//省份

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 22, value = "套餐份量")
    private String packageWeight;//套餐份量

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 23, value = "套餐周期")
    private String setCycle;//套餐周期

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 24, value = "生鲜储存温度")
    private String freshStorageTemp;//生鲜储存温度

    @ExcelProperty(index = 25, value = "价格")
    private String price;//价格


    @ExcelProperty(index = 26, value = "性别")
    private String sex;//性别

    @ExcelProperty(index = 27, value = "年龄")
    private String age;//年龄

    @ExcelProperty(index = 28, value = "特点")
    private String characters;//特点

    @ColumnWidth(value = 20)
    @ExcelProperty(index = 29, value = "评价标签")
    private String evaluationLabel;//评价标签

    @ExcelIgnore
    private Integer fruitId;//水果类别编号
}

